insert overwrite table jms_data_check.yl_threesegcode_sign_ml_dt partition(dt)
select
sum(if(receiver_province_name is null,1,0)) receiver_province_name_null_cnt
,sum(if(receiver_city_name is null,1,0)) receiver_city_name_null_cnt
,sum(if(receiver_area_name is null,1,0)) receiver_area_name_null_cnt
,sum(if(detailed_address is null,1,0)) detailed_address_null_cnt
,count(1) cnt,
'{{ execution_date | cst_ds }}' as dt
from ai_group.yl_threesegcode_sign where dt = '{{ execution_date | cst_ds_nodash }}' ;